1

Hi, could someone please help me sort out this issue? I am trying to export the weekly tasks from MS project into Excel where the team can update the hours worked and remaining effort Is there a way by which i can import it back into the MS Project (microsoft project 2000) and it updates the tasks Could you please describe me the mechanics of it? Help on this or any alternatives would be greatly appreciated Thanks Regards

2

Thanks. I will look into it.

From: jblack@pmconnection via ms-project-l [mailto:ms-project-l@Groups.ITtoolbox.com]
Sent: Friday, 20 March 2009 2:34 PM
To: Rhook, Daniel
Subject: RE:[ms-project-l] Export/import data into MS Project /Excel
[http://userimages.toolbox.com/user/b_681046.jpg]
See this article: Export Data From Microsoft Project to Excel, Update It, and Import Updates From Excel Back into Microsoft Project:
PMConnection - Export MS Project to Excel, Update, Then Import Updates Back Into MS Project

3

See this article: Export Data From Microsoft Project to Excel, Update It, and Import Updates From Excel Back into Microsoft Project:
http://www.pmconnection.com/modules.php?name=News&file=article&sid=60

4

I have been using an online application called LiveProject for a few months now. It syncs with MS Project but allows others to update the project through the Web (with Project Manager approval for each update). Works really well, though there is a cost. If you have multiple people updating projects it really simplifies things.

5

Hi Patty,
Thanks for the information. If you get a chance could you please send me the steps as I see there is no explicit import and export tabs in MS project.

6

If I understand you right, you want to export data to excel, have people make updates and then import it back to your plan? I do this all the time. I created an export map that sends the data to a specific excel file. The “boys” update their particular part of that file and at the end of the day, useing the same import/export map , I import that data back to my plan. Haven’t had any problems and it seems to work well. Hope this helps.

7

I’ve done this on a new plan to build the tasks, but not an existing one. I think it will work. The key thing is making sure no one updates any of the other fields prior to import and make sure when you import back into MSP you use the identical view you used to export out of. (Definitely play with this prior to attempting it.)

8

Hi, I have been tasked with reporting on a weekly basis the=
following information for our project plan=2E Can anyone assist=
with exactly how to do the following reporting for MSProject? =
The boss is looking for detailed reporting along with bar=
graphs, charts, etc=2E=2E=2E? Thanks

% tasks completed by week
Task completed
Task behind schedule
Milestone dependent tasks status
% plan complete each week
% plan complete by tower

9

Thanks Ricahrd fro your answer,

I sent another issue I would like you to have a look please

Cheers

Yves

10

Whenever you need to know how to perform an operation with a Microsoft application go to www.microsoft.com and place your inquiry in the Search box at the top - right of the screen.

Your answer is as follows. Richard Jackson RLJACK01@comcast.net Bothell, WA

United States (change)Microsoft.com Home|Site Map

Search: All Office Online Project 2003 assistance All assistance Training Templates DownloadsClip art and mediaOffice MarketplaceAll Microsoft.comMSN Search

Home
Assistance
Training
Templates
Clip Art and Media
Downloads
Office Marketplace
Work Essentials
Microsoft Office System
Deployment Center

Things To Do

Suggest new content
Get answers from other Office users
Get our newsletter
Contact Us

Export Project data to another file formatHelp
Assistance > Project 2003 > Startup and Settings > Managing Files > Import or Export Project Information

Show All
Hide All
You can export (exporting: Transferring data from Project to another program, such as Excel. When you export data, you choose or create a map that specifies the relationship between the fields in Project and the columns in the ouptut file.) information from Microsoft Office Project 2003 to another format, such as Microsoft Excel (as a workbook or PivotTable), Microsoft Project Database (MPD), Microsoft Access Database (MDB), Open Database Connectivity (ODBC) (ODBC: A vendor-neutral interface, based on the SQL Access Group specifications announced by Microsoft. A developer can use ODBC to gain access to data in a heterogeneous environment of relational and nonrelational databases.)-compliant database formats that Project supports (Microsoft SQL Server and Oracle Server), Extensible Markup Language (XML) (XML: Extensible Markup Language [XML] is a format for delivering rich, structured data from an application in a standard, consistent way. XML describes the content of a document, whereas HTML tags describe how the document looks.), Hypertext Markup Language (HTML) (HTML: An acronym for Hypertext Markup Language, which is a formatting convention for presenting text and graphics on the World Wide Web.), and comma-separated values (CSV) (CSV: The comma-separated values [CSV] file format is an ASCII, record-based text format in which each field is separated by a list-separator character, usually a comma or semicolon. Each task or resource record ends with a carriage return and linefeed.) or text-only format.
On the File menu, click Save As.
In the Save as type box, select the file format you want to export data to.
To export project data to a SQL Server or Oracle Server format, click ODBC, and then continue with step 5.
In the File name box, type a name for the exported file.
Click Save.
Follow the instructions in the Export Wizard to export the data you want into the proper fields of the destination (destination: Where moved, copied, imported, or exported information is inserted; also a view, table, document, or another program. In OLE, the document or program where a linked object resides; also, the document that a hyperlink leads to.) file.
Notes
You can only export an entire project to XML format. Project maps the data automatically, without the Export Wizard. Also, to minimize the file size, fields that contain null values are not included in the exported XML file.
You can include timephased (timephased: Task, resource, or assignment information that is distributed over time. You can review timephased information in any available time period in the fields on the right side of the Task Usage and Resource Usage views.) data when you save the entire project to a database format such as SQL, Oracle, or Access. On the Tools menu, click Options, click the Save tab, and then click the file format you want in the Save Microsoft Office Project files as box. Under Database save options, select the Expand timephased data in the database check box. To set this as the default for future projects, click Set as Default. You cannot include timephased data when you export selected project information.

See Also
About the Export Wizard and the Import Wizard

Export timephased (or timescaled) project data to Excel

File formats supported by Project

Was this information helpful?

How was this information helpful? How can we make this information more helpful?
What are you trying to do?

Your feedback is being submitted.

We appreciate your feedback.
Change my feedback
Although Microsoft cannot respond to every comment, we do use your feedback to improve the information we provide.

Do you need support, or do you have a suggestion about a product? Contact us.

Printer-friendly version

Accessibility | Contact Us | Free Newsletter | Office Worldwide

2006 Microsoft Corporation. All rights reserved. Legal | Trademarks | Privacy Statement

–
425-481-8316
E-mail: RLJACK01@COMCAST.NET

-------------- Original message --------------
From: “yves.donfack via ms-project-l”